---
title: DB-CLL-031 — Retrieve the other-legal-party list for a case
summary: Retrieve the other-legal-party list for a case
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-031 — Retrieve the other-legal-party list for a case

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-031 |
| Operation type | R |
| Execution method | Text |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Inline text SQL |
| Business object | clsOtherLegalParty collection ctor |
| Criteria property | MyRetrieveSQL |
| Lifecycle method | BeforeRetrieve |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| LegalCaseID | Input | NUMBER | N/A | Legal case identifier used to filter other-party rows |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [LEGAL_CASE_EMPLOYER](../database-tables.md#legal_case_employer) | SELECT | LEGAL_CASE_SEQ_NUM, all LEGAL_CASE_EMPLOYER columns |

## Sample SQL

```sql
Select
  LEGAL_CASE_EMPLOYER.LEGAL_CASE_EMPLOYER_SEQ_NUM as OtherPartyID,
  LEGAL_CASE_EMPLOYER.LEGAL_CASE_SEQ_NUM as LegalCaseID,
  LEGAL_CASE_EMPLOYER.EMPLOYER_OTHER_FIRM_SEQ_NUM as EmployerOtherFirmSeqNum,
  LEGAL_CASE_EMPLOYER.ATTORNEY_OTHER_FIRM_SEQ_NUM as AttorneyOtherFirmSeqNum,
  LEGAL_CASE_EMPLOYER.ATTORNEY_LEGAL_PERSON_SEQ_NUM as AttorneyLegalPersonSeqNum,
  LEGAL_CASE_EMPLOYER.EMPLOYER_DISCOVERY_FLAG as EmployerDiscoveryFlag,
  LEGAL_CASE_EMPLOYER.ATTORNEY_DISCOVERY_FLAG as AttorneyDiscoveryFlag
From
  LEGAL_CASE_EMPLOYER
Where
  LEGAL_CASE_EMPLOYER.LEGAL_CASE_SEQ_NUM = :LegalCaseID
```

## Operations and processes

- [Manage other legal parties and request issues](../operations/manage-other-legal-party-and-request-issue.md)

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsOtherLegalParty.vb`